Mastering Excel: Goal Seek & Solver

English | 2017 | ASIN: B0725R1MW| 72 pages | AZW3/PDF/EPUB (conv) | 154 Mb

 
https://imgpile.com/i/n1TGeo

This Excel lesson covers the heavy duty data analysis features of Excel: 

Goal Seek

Scenario manager

Solver 

These features let you tell Excel to run thousands of iterations to find the best answer, whether it be a specific number, the best result (maximum value) or the lower result (minimum value).

I go through each feature step-by-step and include many images to make learning the material easy. No technical jargon, just plain English and a few corny jokes thrown in for good measure.

As with all my lessons, there is a link inside where you can download follow-along workbooks to practice what you read